package com.itheima.mapper;

import com.itheima.domain.Items;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface ItemsMapper {
    //根据订单id查询商品信息
    @Select("select * from items where id in (select items_id from orderdetail where orders_id = #{oid})")
    List<Items> findByOid(int oid);
}
